{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts\n",
    "api = ts.get_apis()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = ts.tick('002930',conn=api,date='2018-04-18')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['datetime']=pd.to_datetime(df['datetime'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 4628 entries, 0 to 4627\n",
      "Data columns (total 4 columns):\n",
      "datetime    4628 non-null datetime64[ns]\n",
      "price       4628 non-null float64\n",
      "vol         4628 non-null int64\n",
      "type        4628 non-null int64\n",
      "dtypes: datetime64[ns](1), float64(1), int64(2)\n",
      "memory usage: 144.7 KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.set_index(df['datetime'],drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>datetime</th>\n",
       "      <th>price</th>\n",
       "      <th>vol</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-04-18 09:25:00</th>\n",
       "      <td>2018-04-18 09:25:00</td>\n",
       "      <td>29.88</td>\n",
       "      <td>6735</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-18 09:30:00</th>\n",
       "      <td>2018-04-18 09:30:00</td>\n",
       "      <td>29.76</td>\n",
       "      <td>134</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-18 09:30:00</th>\n",
       "      <td>2018-04-18 09:30:00</td>\n",
       "      <td>29.95</td>\n",
       "      <td>5148</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-18 09:30:00</th>\n",
       "      <td>2018-04-18 09:30:00</td>\n",
       "      <td>29.88</td>\n",
       "      <td>1026</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-18 09:30:00</th>\n",
       "      <td>2018-04-18 09:30:00</td>\n",
       "      <td>30.00</td>\n",
       "      <td>926</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               datetime  price   vol  type\n",
       "datetime                                                  \n",
       "2018-04-18 09:25:00 2018-04-18 09:25:00  29.88  6735     2\n",
       "2018-04-18 09:30:00 2018-04-18 09:30:00  29.76   134     1\n",
       "2018-04-18 09:30:00 2018-04-18 09:30:00  29.95  5148     0\n",
       "2018-04-18 09:30:00 2018-04-18 09:30:00  29.88  1026     1\n",
       "2018-04-18 09:30:00 2018-04-18 09:30:00  30.00   926     0"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "DatetimeIndex: 4628 entries, 2018-04-18 09:25:00 to 2018-04-18 15:00:00\n",
      "Data columns (total 4 columns):\n",
      "datetime    4628 non-null datetime64[ns]\n",
      "price       4628 non-null float64\n",
      "vol         4628 non-null int64\n",
      "type        4628 non-null int64\n",
      "dtypes: datetime64[ns](1), float64(1), int64(2)\n",
      "memory usage: 180.8 KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "188766"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2018-04-18 09':'2018-04-18 10']['vol'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "total = df['vol'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "383844"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "night = df['2018-04-18 09']['vol'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "33.400287616844345"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "float(night)/total*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "ten = df['2018-04-18 10']['vol'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15.7775033607403"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "float(ten)/total*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "eleven = df['2018-04-18 11']['vol'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3.226310688717291"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "float(eleven)/total*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "thirteen = df['2018-04-18 13']['vol'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "30.195860818457497"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "float(thirteen)/total*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_share =6083*10000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "turnover =float(total)/total_share*100*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "63.10110143021536"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "turnover"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "21.075949367088604"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "float(night)/total_share*100*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]#################################"
     ]
    }
   ],
   "source": [
    "df= ts.broker_tops()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]##"
     ]
    }
   ],
   "source": [
    "jg_df = ts.inst_tops()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>count</th>\n",
       "      <th>bamount</th>\n",
       "      <th>bcount</th>\n",
       "      <th>samount</th>\n",
       "      <th>scount</th>\n",
       "      <th>top3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>联储证券有限责任公司深圳滨海大道易思博证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>4674.28</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>万家乐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>光大证券股份有限公司宁波甬江大道证券营业部</td>\n",
       "      <td>2</td>\n",
       "      <td>3512.18</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>汇金股份,万家乐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>兴业证券股份有限公司深圳分公司</td>\n",
       "      <td>3</td>\n",
       "      <td>7658.30</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>天广中茂,狮头股份,万家乐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>万联证券股份有限公司内江隆昌跃进街证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>1387.11</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>万家乐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>招商证券股份有限公司扬州汶河北路证券营业部</td>\n",
       "      <td>2</td>\n",
       "      <td>2662.11</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>德新交运,万家乐</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     broker  count  bamount  bcount  samount  scount  \\\n",
       "0  联储证券有限责任公司深圳滨海大道易思博证券营业部      1  4674.28       1      0.0       0   \n",
       "1     光大证券股份有限公司宁波甬江大道证券营业部      2  3512.18       2      0.0       0   \n",
       "2           兴业证券股份有限公司深圳分公司      3  7658.30       3      0.0       0   \n",
       "3    万联证券股份有限公司内江隆昌跃进街证券营业部      1  1387.11       1      0.0       0   \n",
       "4     招商证券股份有限公司扬州汶河北路证券营业部      2  2662.11       2      0.0       0   \n",
       "\n",
       "            top3  \n",
       "0            万家乐  \n",
       "1       汇金股份,万家乐  \n",
       "2  天广中茂,狮头股份,万家乐  \n",
       "3            万家乐  \n",
       "4       德新交运,万家乐  "
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>broker</th>\n",
       "      <th>count</th>\n",
       "      <th>bamount</th>\n",
       "      <th>bcount</th>\n",
       "      <th>samount</th>\n",
       "      <th>scount</th>\n",
       "      <th>top3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>华泰证券股份有限公司厦门厦禾路证券营业部</td>\n",
       "      <td>35</td>\n",
       "      <td>32714.00</td>\n",
       "      <td>19</td>\n",
       "      <td>19881.41</td>\n",
       "      <td>16</td>\n",
       "      <td>中海达,华测导航,德邦股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>平安证券股份有限公司广西分公司</td>\n",
       "      <td>35</td>\n",
       "      <td>27522.19</td>\n",
       "      <td>24</td>\n",
       "      <td>10829.05</td>\n",
       "      <td>11</td>\n",
       "      <td>七一二,湖南盐业,新疆火炬,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>国金证券股份有限公司上海奉贤区金碧路证券营业部</td>\n",
       "      <td>33</td>\n",
       "      <td>12056.93</td>\n",
       "      <td>23</td>\n",
       "      <td>4059.31</td>\n",
       "      <td>10</td>\n",
       "      <td>泰永长征,万兴科技,顶点软件,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>平安证券股份有限公司深圳深南东路罗湖商务中心证券营业部</td>\n",
       "      <td>31</td>\n",
       "      <td>8362.81</td>\n",
       "      <td>16</td>\n",
       "      <td>4250.33</td>\n",
       "      <td>15</td>\n",
       "      <td>七一二,恒银金融,中成股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>西藏东方财富证券股份有限公司拉萨金珠西路第一证券营业部</td>\n",
       "      <td>28</td>\n",
       "      <td>13084.79</td>\n",
       "      <td>19</td>\n",
       "      <td>5530.58</td>\n",
       "      <td>9</td>\n",
       "      <td>湖南盐业,安妮股份,七一二,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>国泰君安证券股份有限公司成都北一环路证券营业部</td>\n",
       "      <td>21</td>\n",
       "      <td>27512.97</td>\n",
       "      <td>13</td>\n",
       "      <td>9353.34</td>\n",
       "      <td>8</td>\n",
       "      <td>北新路桥,香溢融通,盈方微,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>财富证券有限责任公司杭州庆春路证券营业部</td>\n",
       "      <td>21</td>\n",
       "      <td>10693.93</td>\n",
       "      <td>13</td>\n",
       "      <td>4846.28</td>\n",
       "      <td>8</td>\n",
       "      <td>七一二,湖南盐业,宏辉果蔬,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>华鑫证券有限责任公司乐清双雁路证券营业部</td>\n",
       "      <td>20</td>\n",
       "      <td>20531.51</td>\n",
       "      <td>11</td>\n",
       "      <td>13090.81</td>\n",
       "      <td>9</td>\n",
       "      <td>聚灿光电,数字认证,铭普光磁,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>中信证券股份有限公司上海分公司</td>\n",
       "      <td>18</td>\n",
       "      <td>17397.14</td>\n",
       "      <td>9</td>\n",
       "      <td>15217.64</td>\n",
       "      <td>9</td>\n",
       "      <td>乐视网,中石科技,德生科技,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>中信证券股份有限公司北京金融大街证券营业部</td>\n",
       "      <td>18</td>\n",
       "      <td>51465.44</td>\n",
       "      <td>10</td>\n",
       "      <td>34737.19</td>\n",
       "      <td>8</td>\n",
       "      <td>浪潮信息,海峡股份,太极股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>华泰证券股份有限公司深圳益田路荣超商务中心证券营业部</td>\n",
       "      <td>17</td>\n",
       "      <td>11854.47</td>\n",
       "      <td>10</td>\n",
       "      <td>7425.47</td>\n",
       "      <td>7</td>\n",
       "      <td>天邑股份,东土科技,爱婴室,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>平安证券股份有限公司北京东花市证券营业部</td>\n",
       "      <td>16</td>\n",
       "      <td>7229.47</td>\n",
       "      <td>8</td>\n",
       "      <td>3730.68</td>\n",
       "      <td>8</td>\n",
       "      <td>彩讯股份,顶点软件,奥拓电子,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>548</th>\n",
       "      <td>华泰证券股份有限公司上海武定路证券营业部</td>\n",
       "      <td>16</td>\n",
       "      <td>9455.11</td>\n",
       "      <td>9</td>\n",
       "      <td>12595.63</td>\n",
       "      <td>7</td>\n",
       "      <td>嘉友国际,盘龙药业,粤传媒,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>国泰君安证券股份有限公司南京太平南路证券营业部</td>\n",
       "      <td>16</td>\n",
       "      <td>14287.66</td>\n",
       "      <td>10</td>\n",
       "      <td>4989.67</td>\n",
       "      <td>6</td>\n",
       "      <td>江龙船艇,紫光股份,大东海A,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>海通证券股份有限公司南京广州路证券营业部</td>\n",
       "      <td>15</td>\n",
       "      <td>6833.64</td>\n",
       "      <td>7</td>\n",
       "      <td>5788.84</td>\n",
       "      <td>8</td>\n",
       "      <td>江龙船艇,凯伦股份,铭普光磁,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>中信证券（山东）有限责任公司淄博分公司</td>\n",
       "      <td>14</td>\n",
       "      <td>9201.20</td>\n",
       "      <td>7</td>\n",
       "      <td>9042.95</td>\n",
       "      <td>7</td>\n",
       "      <td>顶点软件,东土科技,智能自控,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>国信证券股份有限公司深圳泰然九路证券营业部</td>\n",
       "      <td>14</td>\n",
       "      <td>8760.41</td>\n",
       "      <td>5</td>\n",
       "      <td>2044.54</td>\n",
       "      <td>9</td>\n",
       "      <td>新大洲A,罗牛山,宏创控股,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>国泰君安证券股份有限公司深圳深南大道京基一百证券营业部</td>\n",
       "      <td>13</td>\n",
       "      <td>9200.15</td>\n",
       "      <td>8</td>\n",
       "      <td>6719.04</td>\n",
       "      <td>5</td>\n",
       "      <td>恒银金融,铭普光磁,雄塑科技,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>东方证券股份有限公司上海浦东新区春晓路证券营业部</td>\n",
       "      <td>12</td>\n",
       "      <td>5481.03</td>\n",
       "      <td>7</td>\n",
       "      <td>4193.79</td>\n",
       "      <td>5</td>\n",
       "      <td>朗科智能,雄塑科技,科达股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>中国中投证券有限责任公司上海复兴东路证券营业部</td>\n",
       "      <td>12</td>\n",
       "      <td>12117.70</td>\n",
       "      <td>6</td>\n",
       "      <td>12022.58</td>\n",
       "      <td>6</td>\n",
       "      <td>太辰光,陕国投A,威唐工业,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>中信建投证券股份有限公司杭州庆春路证券营业部</td>\n",
       "      <td>12</td>\n",
       "      <td>12556.01</td>\n",
       "      <td>6</td>\n",
       "      <td>10352.22</td>\n",
       "      <td>6</td>\n",
       "      <td>太辰光,大东海A,华测导航,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>湘财证券股份有限公司上海陆家嘴证券营业部</td>\n",
       "      <td>12</td>\n",
       "      <td>4537.86</td>\n",
       "      <td>6</td>\n",
       "      <td>6418.53</td>\n",
       "      <td>6</td>\n",
       "      <td>恒银金融,海航创新,鸿博股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>国金证券股份有限公司上海互联网证券分公司</td>\n",
       "      <td>11</td>\n",
       "      <td>2944.81</td>\n",
       "      <td>5</td>\n",
       "      <td>6772.83</td>\n",
       "      <td>6</td>\n",
       "      <td>宏川智慧,万兴科技,鸿博股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>华泰证券股份有限公司上海普陀区江宁路证券营业部</td>\n",
       "      <td>11</td>\n",
       "      <td>11650.26</td>\n",
       "      <td>6</td>\n",
       "      <td>7857.37</td>\n",
       "      <td>5</td>\n",
       "      <td>嘉友国际,三超新材,今飞凯达,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>长江证券股份有限公司上海东明路证券营业部</td>\n",
       "      <td>11</td>\n",
       "      <td>15520.10</td>\n",
       "      <td>7</td>\n",
       "      <td>8787.74</td>\n",
       "      <td>4</td>\n",
       "      <td>海特高新,光一科技,汇金股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>国信证券股份有限公司上海北京东路证券营业部</td>\n",
       "      <td>11</td>\n",
       "      <td>879.63</td>\n",
       "      <td>2</td>\n",
       "      <td>806.06</td>\n",
       "      <td>9</td>\n",
       "      <td>榕基软件,北新路桥,科达股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>中国中投证券有限责任公司杭州环球中心证券营业部</td>\n",
       "      <td>11</td>\n",
       "      <td>13077.38</td>\n",
       "      <td>9</td>\n",
       "      <td>1900.59</td>\n",
       "      <td>2</td>\n",
       "      <td>光一科技,乐视网,海南瑞泽,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>华鑫证券有限责任公司常州晋陵中路证券营业部</td>\n",
       "      <td>10</td>\n",
       "      <td>8221.72</td>\n",
       "      <td>8</td>\n",
       "      <td>2127.26</td>\n",
       "      <td>2</td>\n",
       "      <td>恒锋信息,德生科技,凯伦股份,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>中信证券股份有限公司杭州延安路证券营业部</td>\n",
       "      <td>10</td>\n",
       "      <td>5130.34</td>\n",
       "      <td>5</td>\n",
       "      <td>6940.99</td>\n",
       "      <td>5</td>\n",
       "      <td>中国科传,民生控股,飞乐音响,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>华泰证券股份有限公司孝感长征路证券营业部</td>\n",
       "      <td>10</td>\n",
       "      <td>5798.16</td>\n",
       "      <td>5</td>\n",
       "      <td>5444.52</td>\n",
       "      <td>5</td>\n",
       "      <td>德生科技,长城科技,科蓝软件,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>方正证券股份有限公司衢州龙游人民路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>427.38</td>\n",
       "      <td>1</td>\n",
       "      <td>恒锋信息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>长城证券股份有限公司杭州分公司</td>\n",
       "      <td>1</td>\n",
       "      <td>393.27</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>飞鹿股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>中国银河证券股份有限公司沈阳三经街证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>225.62</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>飞鹿股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>中国民族证券有限责任公司乌鲁木齐人民路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>535.15</td>\n",
       "      <td>1</td>\n",
       "      <td>飞鹿股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>招商证券股份有限公司上海娄山关路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>1301.77</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>信息发展</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>恒泰证券股份有限公司呼和浩特新城北街证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>284.96</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>光一科技</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>683</th>\n",
       "      <td>东莞证券股份有限公司东莞常平分公司</td>\n",
       "      <td>1</td>\n",
       "      <td>325.07</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>光一科技</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>中泰证券股份有限公司青岛正阳路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>724.66</td>\n",
       "      <td>1</td>\n",
       "      <td>朗玛信息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>634</th>\n",
       "      <td>光大证券股份有限公司广安金安大道证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>784.06</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>荣之联</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>637</th>\n",
       "      <td>南京证券股份有限公司南京热河路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>566.35</td>\n",
       "      <td>1</td>\n",
       "      <td>荣之联</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>638</th>\n",
       "      <td>中国银河证券股份有限公司德清证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>526.94</td>\n",
       "      <td>1</td>\n",
       "      <td>荣之联</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>644</th>\n",
       "      <td>东方证券股份有限公司桂林中山中路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>1956.05</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>真视通</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>华创证券有限责任公司贵阳新华路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>531.34</td>\n",
       "      <td>1</td>\n",
       "      <td>真视通</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>民生证券股份有限公司厦门分公司</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>311.42</td>\n",
       "      <td>1</td>\n",
       "      <td>真视通</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>广发证券股份有限公司中山小榄营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>201.00</td>\n",
       "      <td>1</td>\n",
       "      <td>真视通</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>申万宏源西部证券有限公司南宁英华路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>1051.16</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>盘龙药业</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>中国银河证券股份有限公司北京立通路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>698.20</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>今飞凯达</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655</th>\n",
       "      <td>国泰君安证券股份有限公司吉林松江路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>544.06</td>\n",
       "      <td>1</td>\n",
       "      <td>今飞凯达</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657</th>\n",
       "      <td>万和证券股份有限公司广州中山大道西证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>326.81</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>钧达股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659</th>\n",
       "      <td>西部证券股份有限公司柳州海关路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>248.63</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>钧达股份</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660</th>\n",
       "      <td>广发证券股份有限公司深圳新安二路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>335.45</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>惠威科技</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661</th>\n",
       "      <td>中信证券股份有限公司汕头海滨路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>580.77</td>\n",
       "      <td>1</td>\n",
       "      <td>惠威科技</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>国海证券股份有限公司深圳中心路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>377.09</td>\n",
       "      <td>1</td>\n",
       "      <td>德生科技</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>广发证券股份有限公司深圳高新南一道证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>500.00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>泰永长征</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>长江证券股份有限公司吉安井冈山大道证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>858.49</td>\n",
       "      <td>1</td>\n",
       "      <td>名臣健康</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>中国中投证券有限责任公司佛山顺德东乐路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>396.98</td>\n",
       "      <td>1</td>\n",
       "      <td>三五互联</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>中信建投证券股份有限公司宁波镇明路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1717.28</td>\n",
       "      <td>1</td>\n",
       "      <td>朗玛信息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>平安证券股份有限公司郑州金水东路证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1204.24</td>\n",
       "      <td>1</td>\n",
       "      <td>朗玛信息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>681</th>\n",
       "      <td>方正证券股份有限公司北京玉带河东街证券营业部</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>880.56</td>\n",
       "      <td>1</td>\n",
       "      <td>朗玛信息</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1290</th>\n",
       "      <td>平安证券股份有限公司福建分公司</td>\n",
       "      <td>1</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>2499.26</td>\n",
       "      <td>1</td>\n",
       "      <td>狮头股份</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1291 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           broker  count   bamount  bcount   samount  scount  \\\n",
       "140          华泰证券股份有限公司厦门厦禾路证券营业部     35  32714.00      19  19881.41      16   \n",
       "71                平安证券股份有限公司广西分公司     35  27522.19      24  10829.05      11   \n",
       "190       国金证券股份有限公司上海奉贤区金碧路证券营业部     33  12056.93      23   4059.31      10   \n",
       "16    平安证券股份有限公司深圳深南东路罗湖商务中心证券营业部     31   8362.81      16   4250.33      15   \n",
       "128   西藏东方财富证券股份有限公司拉萨金珠西路第一证券营业部     28  13084.79      19   5530.58       9   \n",
       "10        国泰君安证券股份有限公司成都北一环路证券营业部     21  27512.97      13   9353.34       8   \n",
       "294          财富证券有限责任公司杭州庆春路证券营业部     21  10693.93      13   4846.28       8   \n",
       "228          华鑫证券有限责任公司乐清双雁路证券营业部     20  20531.51      11  13090.81       9   \n",
       "227               中信证券股份有限公司上海分公司     18  17397.14       9  15217.64       9   \n",
       "371         中信证券股份有限公司北京金融大街证券营业部     18  51465.44      10  34737.19       8   \n",
       "110    华泰证券股份有限公司深圳益田路荣超商务中心证券营业部     17  11854.47      10   7425.47       7   \n",
       "146          平安证券股份有限公司北京东花市证券营业部     16   7229.47       8   3730.68       8   \n",
       "548          华泰证券股份有限公司上海武定路证券营业部     16   9455.11       9  12595.63       7   \n",
       "174       国泰君安证券股份有限公司南京太平南路证券营业部     16  14287.66      10   4989.67       6   \n",
       "173          海通证券股份有限公司南京广州路证券营业部     15   6833.64       7   5788.84       8   \n",
       "64            中信证券（山东）有限责任公司淄博分公司     14   9201.20       7   9042.95       7   \n",
       "187         国信证券股份有限公司深圳泰然九路证券营业部     14   8760.41       5   2044.54       9   \n",
       "398   国泰君安证券股份有限公司深圳深南大道京基一百证券营业部     13   9200.15       8   6719.04       5   \n",
       "142      东方证券股份有限公司上海浦东新区春晓路证券营业部     12   5481.03       7   4193.79       5   \n",
       "155       中国中投证券有限责任公司上海复兴东路证券营业部     12  12117.70       6  12022.58       6   \n",
       "192        中信建投证券股份有限公司杭州庆春路证券营业部     12  12556.01       6  10352.22       6   \n",
       "48           湘财证券股份有限公司上海陆家嘴证券营业部     12   4537.86       6   6418.53       6   \n",
       "238          国金证券股份有限公司上海互联网证券分公司     11   2944.81       5   6772.83       6   \n",
       "455       华泰证券股份有限公司上海普陀区江宁路证券营业部     11  11650.26       6   7857.37       5   \n",
       "162          长江证券股份有限公司上海东明路证券营业部     11  15520.10       7   8787.74       4   \n",
       "171         国信证券股份有限公司上海北京东路证券营业部     11    879.63       2    806.06       9   \n",
       "20        中国中投证券有限责任公司杭州环球中心证券营业部     11  13077.38       9   1900.59       2   \n",
       "230         华鑫证券有限责任公司常州晋陵中路证券营业部     10   8221.72       8   2127.26       2   \n",
       "95           中信证券股份有限公司杭州延安路证券营业部     10   5130.34       5   6940.99       5   \n",
       "116          华泰证券股份有限公司孝感长征路证券营业部     10   5798.16       5   5444.52       5   \n",
       "...                           ...    ...       ...     ...       ...     ...   \n",
       "717        方正证券股份有限公司衢州龙游人民路证券营业部      1      0.00       0    427.38       1   \n",
       "718               长城证券股份有限公司杭州分公司      1    393.27       1      0.00       0   \n",
       "719        中国银河证券股份有限公司沈阳三经街证券营业部      1    225.62       1      0.00       0   \n",
       "721      中国民族证券有限责任公司乌鲁木齐人民路证券营业部      1      0.00       0    535.15       1   \n",
       "686         招商证券股份有限公司上海娄山关路证券营业部      1   1301.77       1      0.00       0   \n",
       "684       恒泰证券股份有限公司呼和浩特新城北街证券营业部      1    284.96       1      0.00       0   \n",
       "683             东莞证券股份有限公司东莞常平分公司      1    325.07       1      0.00       0   \n",
       "682          中泰证券股份有限公司青岛正阳路证券营业部      1      0.00       0    724.66       1   \n",
       "634         光大证券股份有限公司广安金安大道证券营业部      1    784.06       1      0.00       0   \n",
       "637          南京证券股份有限公司南京热河路证券营业部      1      0.00       0    566.35       1   \n",
       "638           中国银河证券股份有限公司德清证券营业部      1      0.00       0    526.94       1   \n",
       "644         东方证券股份有限公司桂林中山中路证券营业部      1   1956.05       1      0.00       0   \n",
       "647          华创证券有限责任公司贵阳新华路证券营业部      1      0.00       0    531.34       1   \n",
       "648               民生证券股份有限公司厦门分公司      1      0.00       0    311.42       1   \n",
       "650             广发证券股份有限公司中山小榄营业部      1      0.00       0    201.00       1   \n",
       "651        申万宏源西部证券有限公司南宁英华路证券营业部      1   1051.16       1      0.00       0   \n",
       "653        中国银河证券股份有限公司北京立通路证券营业部      1    698.20       1      0.00       0   \n",
       "655        国泰君安证券股份有限公司吉林松江路证券营业部      1      0.00       0    544.06       1   \n",
       "657        万和证券股份有限公司广州中山大道西证券营业部      1    326.81       1      0.00       0   \n",
       "659          西部证券股份有限公司柳州海关路证券营业部      1    248.63       1      0.00       0   \n",
       "660         广发证券股份有限公司深圳新安二路证券营业部      1    335.45       1      0.00       0   \n",
       "661          中信证券股份有限公司汕头海滨路证券营业部      1      0.00       0    580.77       1   \n",
       "667          国海证券股份有限公司深圳中心路证券营业部      1      0.00       0    377.09       1   \n",
       "670        广发证券股份有限公司深圳高新南一道证券营业部      1    500.00       1      0.00       0   \n",
       "673        长江证券股份有限公司吉安井冈山大道证券营业部      1      0.00       0    858.49       1   \n",
       "677      中国中投证券有限责任公司佛山顺德东乐路证券营业部      1      0.00       0    396.98       1   \n",
       "679        中信建投证券股份有限公司宁波镇明路证券营业部      1      0.00       0   1717.28       1   \n",
       "680         平安证券股份有限公司郑州金水东路证券营业部      1      0.00       0   1204.24       1   \n",
       "681        方正证券股份有限公司北京玉带河东街证券营业部      1      0.00       0    880.56       1   \n",
       "1290              平安证券股份有限公司福建分公司      1      0.00       0   2499.26       1   \n",
       "\n",
       "                 top3  \n",
       "140    中海达,华测导航,德邦股份,  \n",
       "71     七一二,湖南盐业,新疆火炬,  \n",
       "190   泰永长征,万兴科技,顶点软件,  \n",
       "16     七一二,恒银金融,中成股份,  \n",
       "128    湖南盐业,安妮股份,七一二,  \n",
       "10     北新路桥,香溢融通,盈方微,  \n",
       "294    七一二,湖南盐业,宏辉果蔬,  \n",
       "228   聚灿光电,数字认证,铭普光磁,  \n",
       "227    乐视网,中石科技,德生科技,  \n",
       "371   浪潮信息,海峡股份,太极股份,  \n",
       "110    天邑股份,东土科技,爱婴室,  \n",
       "146   彩讯股份,顶点软件,奥拓电子,  \n",
       "548    嘉友国际,盘龙药业,粤传媒,  \n",
       "174   江龙船艇,紫光股份,大东海A,  \n",
       "173   江龙船艇,凯伦股份,铭普光磁,  \n",
       "64    顶点软件,东土科技,智能自控,  \n",
       "187    新大洲A,罗牛山,宏创控股,  \n",
       "398   恒银金融,铭普光磁,雄塑科技,  \n",
       "142   朗科智能,雄塑科技,科达股份,  \n",
       "155    太辰光,陕国投A,威唐工业,  \n",
       "192    太辰光,大东海A,华测导航,  \n",
       "48    恒银金融,海航创新,鸿博股份,  \n",
       "238   宏川智慧,万兴科技,鸿博股份,  \n",
       "455   嘉友国际,三超新材,今飞凯达,  \n",
       "162   海特高新,光一科技,汇金股份,  \n",
       "171   榕基软件,北新路桥,科达股份,  \n",
       "20     光一科技,乐视网,海南瑞泽,  \n",
       "230   恒锋信息,德生科技,凯伦股份,  \n",
       "95    中国科传,民生控股,飞乐音响,  \n",
       "116   德生科技,长城科技,科蓝软件,  \n",
       "...               ...  \n",
       "717              恒锋信息  \n",
       "718              飞鹿股份  \n",
       "719              飞鹿股份  \n",
       "721              飞鹿股份  \n",
       "686              信息发展  \n",
       "684              光一科技  \n",
       "683              光一科技  \n",
       "682              朗玛信息  \n",
       "634               荣之联  \n",
       "637               荣之联  \n",
       "638               荣之联  \n",
       "644               真视通  \n",
       "647               真视通  \n",
       "648               真视通  \n",
       "650               真视通  \n",
       "651              盘龙药业  \n",
       "653              今飞凯达  \n",
       "655              今飞凯达  \n",
       "657              钧达股份  \n",
       "659              钧达股份  \n",
       "660              惠威科技  \n",
       "661              惠威科技  \n",
       "667              德生科技  \n",
       "670              泰永长征  \n",
       "673              名臣健康  \n",
       "677              三五互联  \n",
       "679              朗玛信息  \n",
       "680              朗玛信息  \n",
       "681              朗玛信息  \n",
       "1290             狮头股份  \n",
       "\n",
       "[1291 rows x 7 columns]"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by='count',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
